CREATE TABLE jms_dm.dm_sqs_problem_reply_time_cnt_dt (
                                                         select_type tinyint(4) NULL COMMENT "查询类型（1接受网点 2 登记网点类型）",
                                                         network_code varchar(30) NULL COMMENT "网点code",
                                                         manage_code varchar(30) NULL COMMENT "大区code",
                                                         agent_code varchar(30) NULL COMMENT "代理区code",
                                                         create_date date NULL COMMENT "创建日期",
                                                         network_id varchar(30) NULL COMMENT "网点id",
                                                         network_name varchar(80) NULL COMMENT "网点name",
                                                         network_parent_name varchar(80) NULL COMMENT "父级网点名称",
                                                         manage_name varchar(80) NULL COMMENT "大区name",
                                                         agent_name varchar(80) NULL COMMENT "代理区code",
                                                         in_out_bound int(11) NULL COMMENT "进出港1 进港 2 出港",
                                                         order_source_name varchar(80) NULL COMMENT "订单来源",
                                                         total int(11) NULL COMMENT "合计问题件票数",
                                                         no_reply_total int(11) NULL COMMENT "未回复票数",
                                                         all_time1 int(11) NULL COMMENT "票数_时段1,1h以内（含1小时）",
                                                         all_time2 int(11) NULL COMMENT "票数_时段2,1-4小时（含4小时，不含1小时",
                                                         all_time3 int(11) NULL COMMENT "票数_时段3,4-24小时（含24小时，不含4小时）",
                                                         all_time4 int(11) NULL COMMENT "票数_时段4,24-72小时（含72小时，不含24小时）",
                                                         all_time5 int(11) NULL COMMENT "票数_时段5,超72小时（不含72小时）",
                                                         need_reply_total int(11) NULL COMMENT "需要回复_合计问题件票数",
                                                         need_no_reply_total int(11) NULL COMMENT "需要回复_未回复票数",
                                                         need_reply_time1 int(11) NULL COMMENT "需要回复票数_时段1_时段11h以内（含1小时）",
                                                         need_reply_time2 int(11) NULL COMMENT "需要回复票数_时段2_时段21-4小时（含4小时，不含1小时））",
                                                         need_reply_time3 int(11) NULL COMMENT "需要回复票数_时段3_时段34-24小时（含24小时，不含4小时）",
                                                         need_reply_time4 int(11) NULL COMMENT "需要回复票数_时段4_时段424-72小时（含72小时，不含24小时）",
                                                         need_reply_time5 int(11) NULL COMMENT "需要回复票数_时段5_时段5超72小时（不含72小时）",
                                                         network_type int(11) NULL COMMENT "网点类型:1-总部,2-代理区,3-加盟商,4-中心,5-集散点,6-网点",
                                                         date_time date NULL COMMENT "查询时间=create_date"
) ENGINE=OLAP
DUPLICATE KEY(select_type, network_code, manage_code, agent_code)
COMMENT "服务质量-问题件看板汇总"
PARTITION BY RANGE(date_time)
(START ("2023-10-01") END ("2023-12-22") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(select_type) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2",
"enable_persistent_index" = "false"
);